Create Summary Dashboard Visualization Part Two 12


  Create Questions & First Response Time Visualization (Last 12 Weeks)

·       Select Line and Clustered Column Chart

·       For the Shared Axis Field For the Week Hierarchy, For the week and DayofWeek

·       For Column values Field Drag and Drop Answer Needed Qns per day

·       For Line values Field Drag and Drop First Response Hrs and Response HR Goal

·       Go to The Filters click on For the Week

-        Select Top N

-        Show Items Top  12

-        Drag and drop on by value Weekend from the date table 


Formatting

·       General

-        X- position 1272

-        Y- position 456

-        Width 1228

-         Hight 456

·       Legend

-        Color Black

-        Font Family Segoe (Bold)

-        Text Size 16

·       X-Axis

-        Color-------------- Black

-        Text Size ----------15

-        Title Color --------Black

-        Title Size---------- 16

·       Y-Axis

-        Color --------#F1C40F

-        Text ----------16

-        Show Secondary ---On

-        Align Zeros --------On

-        Scaler type -------- Liner

-        Color --------------Black

-        Text ----------------16

·       Data Color

-        First Response Hrs -----#34495E

-        Response HR Goal------#A0D1FF

·       Data Lab

-        Color -------Black

-        Text Size -----16

-        Show Background ----ON

-        Background Color ----White

-        Custom Size --------ON

      Answer Needed Qns Per Day

-        Show -----ON

-        Color ------#F1C40F

-        Text -------16

-        Show Background ---ON

-        Background Color ----31%

 

·       Shapes

-         Shade area ------ON

-         Width ------- 4

·       Title

-        Title text

       . Click Fx

-        Font Color --------#F1C40F

-        Background Color-----#34495E

-        Alignment -------Center

-        Text --------25

·       Background

-        Color ---------White

-        Transparency -------15%

·       Border --------ON

-        Color ------Black

·       Shadow -------------ON

-        Color -------Black

·       Tooltip ---------ON


  Create Post & Rolling Month Change (Last 12 Weeks)

·       Select Line and Clustered Column Chart

·       For the Shared Axis Field For the Week Hierarchy, For the week and DayofWeek

·       For Column values Field Drag and Drop Total Posts per day

·       For Line values Field Drag and Drop Rolling Month % Change


Formatting

·       General

-        X- position 1272

-        Y- position 936

-        Width 1228

-         Hight 456

·       Legend

-        Color Black

-        Font Family Segoe (Bold)

-        Text Size 16

·       X-Axis

-        Color-------------- Black

-        Text Size ----------15

-        Title Color --------Black

-        Title Size---------- 16

·       Y-Axis

-        Color --------#F1C40F

-        Text ----------16

-        Show Secondary ---On

-        Align Zeros --------On

-        Scaler type -------- Liner

-        Color --------------Black

-        Text ----------------16

·       Data Color

-        Rolling Month ------#34495E

-        Default ------------#F1C40F

·       Data Lab

-        Color -------Black

-        Text Size -----16

-        Show Background ----ON

-        Background Color ----White

-        Custom Size --------ON

      Answer Needed Qns Per Day

-        Show -----ON

-        Color ------#F1C40F

-        Text -------16

-        Show Background ---ON

-        Background Color ----31%

·       Shapes

-         Shade area ------ON

-         Width ------- 4

·       Title

-        Title text

       . Click Fx

-        Font Color --------#F1C40F

-        Background Color-----#34495E

-        Alignment -------Center

-        Text --------25

·       Background

-        Color ---------White

-        Transparency -------15%

·       Border --------ON

-        Color ------Black

·       Shadow -------------ON

-        Color -------Black

·       Tooltip ---------ON

First Response Time

·       Select Scroller Visual

·       Measure Absolute First Response Hrs

Formatting

·       General

-        X- position 0

-        Y- position 1392

-        Width 2496

-         Hight 96

·       Scroller

-        Text Color ----White

-        Background Color ------#34495E

·       Title

-        Title text

       . First Response Time in Hrs

-        Font Color -----------Black

-        Background Color -------White

        . Alignment ----------Center

        . Text Size ---------16  

How to create the measure that show last 12 weeks in power bi 

https://www.youtube.com/watch?v=jBPLm5BHl2c